DB Repair tabs: Reset, Rebuild, NetContacts, Logging, PCI

These functions restore database items to the states they held when last upgraded or installed.

■ Reset All Views: Drop and recreate all iMIS System Views to what they were at the last install/upgrade. Custom Views are unaffected.

■ Reset All Triggers: Drop and recreate all iMIS System Triggers to what they were at the last install/upgrade. Custom Triggers are unaffected.

■ Reset All Indexes: Drop and recreate all iMIS System Indexes to what they were at the last install/upgrade. This preserves custom indexes, as well as primary and alternate key indexes, because of foreign key constraints (relevant only for newer .NET tables).

Caution! This function will not complete successfully if your iMIS database contains any full-text indexes. You must first drop all full-text indexes that might exist in your iMIS database, and then manually re-create them after you have finished running this function.

■ Reset Report Specs: Reset all iMIS Standard Report Specifications to what they were at the time of the last install or upgrade. These specifications are found in iMIS Desktop, from the menu Utilities > Report Specs. Custom report specifications are not affected.

■ Reset All Stored Procedures: Drop and recreate all iMIS System Stored Procedures to what they were at the last install/upgrade. Custom Procedures are unaffected.

■ Reset All Functions: Drop and recreate all iMIS System Functions to what they were at the last install/upgrade. Custom User Defined Functions (UDFs) are unaffected.

■ Reset All Permissions: Reset the permissions on all iMIS System database objects to what they were at the last install/upgrade. This grants permissions to all iMIS System database objects to the iMIS group as required.

■ Rebuild Name_All View: Rebuild the Name_All View, which is not rebuilt by Reset All Views.

■ Rebuild All Existing Indexes: Rebuild all iMIS System Indexes. This runs a DBCC REINDEX command against all existing iMIS table indexes.

NetContacts commands help you avoid errors when importing contact records into iMIS. (“NetContacts” takes its name from the CsNetContacts business object.)

In iMIS 15, a Name table trigger copies data to numerous .NET tables (such as ContactMain, Individual, Institute); the NetContacts tab helps you achieve the same synchronization when you import contacts into iMIS (see Importing contact records).

■ Disable Name Table Trigger: Disable the trigger on the Name Table that keeps the NetContacts synchronized.

■ Enable Name Table Trigger: Enable the trigger on the Name Table that keeps the NetContacts synchronized.

■ Synchronize NetContacts: Synchronize the NetContacts after loading the Name table with the trigger disabled.

■ Purge Unused Users: Permanently removes user entries from .NET tables that were previously purged from Client/Server tables.

■ Purge Unused Contacts: Permanently removes contact entries from .NET tables that were previously purged from Client/Server tables.

■ Log File History: View list of log files, from most recent to oldest and select a file to view.

■ Clear Log File: Back up the current log file to a history file, then clear the current log file. This is helpful to keep a shorter, recent list.

■ Purge All Cardholder Information: Removes all existing cardholder information from your iMIS database (one-time process).

■ Reset Encryption Key and Data: (annual process) Resets the encryption keys and re-encrypts cardholder data; writes these events to the PCIAuditLog.

■ Remove Historical Encryption Keys: (annual process) Deletes the prior encryption keys and writes the event to the PCIAuditLog. Once done, email links encrypted with such keys cannot resolve.

(NRDS clients only) Creates needed items for the data synchronization bridge. See Creating NRDS items.

(VAT organizations only) If you enable VAT Inclusive in AR/Cash, lets you convert your existing product/event pricing to include the VAT tax amount. See Converting to VAT Inclusive.